Use case - NDC Analytics

Charge Description Master (CDM) and National Drug Code (NDC) profile filters stratify the data to include or exclude patients that received selected charge codes or drug codes during their stay at the hospital. Because of the patient-level data used in this exercise, unlock Clinical Analytics before you begin.

Create an NDC-based profile

For this exercise, we create a profile for patients within surgical MS-DRGs and who received IV Tylenol (Ofirmev).

  1. Within the scorecard you plan to use, click the Profiles icon in the top right corner of your screen to open the profile manager screen.
  2. Click +Add Profile in the upper right corner to create and customize a new profile.
  3. In the upper left corner, assign your profile a descriptive name. For example, "Surgical patients with IV Tylenol."

  4. To add a filter for the surgical MS-DRGs, click the Add dropdown in the upper right corner and select DRG Type.

  5. In the filter options, select the check box next to Surgical.

  6. Next, we add a filter for patients receiving IV Tylenol. Within the same profile, add another filter for National Drug Codes.

  7. Your added DRG Filter is still included in this profile, and it has just been minimized. Enter “Ofirmev” into the inline filter above the Description column, and click the check box next to the NDC code. You can use the table columns to search for pharmaceuticals by NDC, Description, Therapeutic Class, and/or Pharmacological Class.

  8. Click Save in the bottom left corner to save the profile and return to the Profile Manager screen.

NOTE: When using this profile in Clinical Analytics, it pulls encounters from your data that were grouped into a surgical MS-DRG and had an NDC code for Ofirmev.

Create a complimentary NDC-based profile

Now, let's create the inverse profile: patients within surgical DRGs that did NOT receive IV Tylenol. This is helpful when trying to compare outcomes of patients with the profile that you created above. For this exercise, we leverage the Copy Profile feature because the profile we are now creating is similar to the one that we just created.

  1. If you are not still viewing the Profile Manager from the previous step 7, click the Profiles icon in the upper right corner.
  2. Locate the profile you built in the first portion of this walk-through, and click the Copy icon in the Actions column.
  3. Give your new profile a descriptive name, such as "Surgical Patient NO IV Tylenol."

  4. Click OK and locate the new profile in the Profile Manager list. We need to change this copied profile to differentiate it from the first profile. Click the pencil icon in the Actions column of your new profile to edit it.
  5. Notice the two filters that we added in the first portion of the walkthrough. To capture surgical patients that did NOT receive IV Tylenol, we need to change the logic of the NDC filter from Include to Exclude. Click the [+] on the right side of the NDC profile filter to expand the filter details, then click the radio button next to Exclude.

  6. Click Save in the bottom left corner to save the profile and return to the Profile Manager screen.
  7. Click the green check in the top right corner to exit the Profile Manager and view your scorecard.

NOTE: You now have a profile for surgical inpatients that received Ofirmev and a profile for surgical inpatients that did not. You can use these profiles in the Clinical Analytics tools to validate decisions regarding the use of this medication.